<?php
class Itc_Model_DbTable_PatientCard extends Itc_Db_Table_Abstract
{

    protected $_name	= 'patient_card';
    protected $_primary	= 'record_id';

	protected $search_fields = array(
		'reason',
		'notes',
		'recommendations'
	);

	protected $_referenceMap = array(
		'Doctor' => array(
			'columns' 		=> 'doctor_id',
			'refTableClass' => 'Itc_Model_DbTable_Doctor',
			'refColumns' 	=> 'id'
		),
		'Patient' => array(
			'columns' 		=> 'patient_id',
			'refTableClass' => 'Itc_Model_DbTable_Patient',
			'refColumns' 	=> 'id'
		),
		'Disease' => array(
			'columns' 		=> 'diagnosis',
			'refTableClass' => 'Itc_Model_DbTable_Diseases',
			'refColumns' 	=> 'disease_id'
		)
	);
    
}

